fairnesscoop /
permacoop
| Conditions | 1 |
| Total Lines | 17 |
| Code Lines | 10 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 0 | ||
| 1 | import {MigrationInterface, QueryRunner} from 'typeorm'; |
||
| 5 | |||
| 6 | public async up(queryRunner: QueryRunner): Promise<any> { |
||
| 7 | await queryRunner.query( |
||
| 8 | `CREATE TABLE "file" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "name" character varying NOT NULL, "size" integer NOT NULL, "mimeType" character varying NOT NULL, "uploadedAt" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "PK_36b46d232307066b3a2c9ea3a1d" PRIMARY KEY ("id"))`, |
||
| 9 | undefined |
||
| 10 | ); |
||
| 11 | await queryRunner.query( |
||
| 12 | `CREATE TABLE "pay_slip" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "date" TIMESTAMP NOT NULL, "fileId" uuid NOT NULL, "userId" uuid NOT NULL, CONSTRAINT "PK_6a3474cef7b4be2033694e1b2ae" PRIMARY KEY ("id"))`, |
||
| 13 | undefined |
||
| 14 | ); |
||
| 15 | await queryRunner.query( |
||
| 16 | `ALTER TABLE "pay_slip" ADD CONSTRAINT "FK_252d4cbbedfa1f1fb66ada01a07" FOREIGN KEY ("fileId") REFERENCES "file"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`, |
||
| 17 | undefined |
||
| 18 | ); |
||
| 19 | await queryRunner.query( |
||
| 20 | `ALTER TABLE "pay_slip" ADD CONSTRAINT "FK_e70c3a9343494ab691a33302fe5" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`, |
||
| 21 | undefined |
||
| 22 | ); |
||
| 38 |
